package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "qb_white", simpleName = "", engine = MysqlDriver.MyISAM, comment = "内部户白名单")
public class _DDL_QbWhite {

    @_DDL_Primary()
    @_DDL_Column(name = "w_id", type = SqlType.INT, nullable = false, autoIncrement = true, comment = "名单ID")
    private Integer id;

    @_DDL_Unique(name = "k_id_card")
    @_DDL_Column(name = "w_id_card", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "证件号码")
    private String idCard;

    @_DDL_Column(name = "w_name", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "姓名")
    private String name;

    @_DDL_Column(name = "w_phone", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "手机号")
    private String phone;

    @_DDL_Column(name = "w_cr_date", type = SqlType.DATETIME, nullable = false, comment = "创建时间")
    private java.time.LocalDateTime crDate;

}
